The OPTION keyword denotes options the user can pass in with the command. These options are Teiid-specific and not covered by any SQL specification.

Usage:

OPTION option, \(option)*

Supported options:

• MAKEDEP table [(,table)*] - specifies source tables that should be made dependent in the join

• MAKENOTDEP table [(,table)*] - prevents a dependent join from being used

• NOCACHE [table (,table)*] - prevents cache from being used for all tables or for the given tables

Examples:

• OPTION MAKEDEP table1

• OPTION NOCACHE

All tables specified in the OPTION clause should be fully qualified.